package com.dmgis.hndz.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.dmgis.hndz.pojo.Qxda02a;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @className Qxda02aMapper
 * @Description TODO
 * @Author lhfy
 * @Version 1.0
 */

@Mapper
@DS("slave_qxdata")
public interface Qxda02aMapper {
    @Select("SELECT qxda02a010, qxda02a020, qxda02a030, qxda02a040, qxda02a050, qxda02a060, qxda02a070, qxda02a080, qxda02a090 FROM qxda02a")
    List<Qxda02a> getQxda02aInfo();

    @Update("UPDATE qxda02a SET qxda02a030 = #{qxda02a030}, qxda02a040 = #{qxda02a040}, qxda02a050 = #{qxda02a050}, qxda02a060 = #{qxda02a060}, qxda02a070 = #{qxda02a070}, qxda02a080 = #{qxda02a080}, qxda02a090 = #{qxda02a090} WHERE qxda02a020 = #{qxda02a020}")
    int updateQxda02aInfo(Qxda02a qxda02a);
}
